package com.ericsson.smart.dto;

import java.io.Serializable;
import java.util.Date;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;

/*@NamedQuery(name = "geographicsDimensionsData",
 //query="select g from GeographyDimensionsDTO g where g.area = :area")
 query="select count(g),zip_code from PUBLIC.GEOGRAPHY_DIMENSIONS g where area="+
 */
@Entity
@Table(name = "DIM_TIME")
public class TimeDimension implements Serializable {

	private static final long serialVersionUID = 1L;

	public TimeDimension() {
	}

	@Id
	@Column(name = "TIME_ID")
	private String timeId;

	@Column(name = "THE_DATE")
	private Date theDate;

	@Column(name = "THE_DAY")
	private String theDay;

	@Column(name = "THE_MONTH")
	private String theMonth;

	@Column(name = "THE_YEAR")
	private String theYear;

	@Column(name = "DAY_OF_MONTH")
	private int dayOfMonth;

	@Column(name = "WEEK_OF_YEAR")
	private int weekOfYear;

	@Column(name = "MONTH_OF_YEAR")
	private int monthOfYear;

	@Column(name = "QUARTER")
	private String quarter;

	public TimeDimension(String timeId, Date theDate, String theDay, String theMonth,
			String theYear, int dayOfMonth, int weekOfYear, int monthOfYear, String quarter) {
		this.timeId = timeId;
		this.theDate = theDate;
		this.theDay = theDay;
		this.theMonth = theMonth;
		this.theYear = theYear;
		this.dayOfMonth = dayOfMonth;
		this.weekOfYear = weekOfYear;
		this.monthOfYear = monthOfYear;
		this.quarter = quarter;
	}

	public String getTimeId() {
		return timeId;
	}

	public void setTimeId(String timeId) {
		this.timeId = timeId;
	}

	public Date getTheDate() {
		return theDate;
	}

	public void setTheDate(Date theDate) {
		this.theDate = theDate;
	}

	public String getTheDay() {
		return theDay;
	}

	public void setTheDay(String theDay) {
		this.theDay = theDay;
	}

	public String getTheMonth() {
		return theMonth;
	}

	public void setTheMonth(String theMonth) {
		this.theMonth = theMonth;
	}

	public String getTheYear() {
		return theYear;
	}

	public void setTheYear(String theYear) {
		this.theYear = theYear;
	}

	public int getDayOfMonth() {
		return dayOfMonth;
	}

	public void setDayOfMonth(int dayOfMonth) {
		this.dayOfMonth = dayOfMonth;
	}

	public int getWeekOfYear() {
		return weekOfYear;
	}

	public void setWeekOfYear(int weekOfYear) {
		this.weekOfYear = weekOfYear;
	}

	public int getMonthOfYear() {
		return monthOfYear;
	}

	public void setMonthOfYear(int monthOfYear) {
		this.monthOfYear = monthOfYear;
	}

	public String getQuarter() {
		return quarter;
	}

	public void setQuarter(String quarter) {
		this.quarter = quarter;
	}

}
